-- Creating & Populating Tables for Triggers

CREATE TABLE RevClass	(
	classNumber	CHAR(8),
	facId	 	CHAR(6)  NOT NULL,
	schedule  	CHAR(8),
	room		CHAR(6),
	currentEnroll	number,
	maxEnroll	number
	);
CREATE TABLE RevEnroll	(
	stuId		CHAR(6),	
	classNumber	CHAR(8),
	grade		CHAR(2));

INSERT INTO revCLASS VALUES('ART103A','F101','MWF9','H221',3,25);
INSERT INTO revCLASS VALUES('CSC201A','F105','TuThF10','M110',2,20);
INSERT INTO revCLASS VALUES('CSC203A','F105','MThF12','M110',0,20);
INSERT INTO revCLASS VALUES('HST205A','F115','MWF11','H221',1,35);
INSERT INTO revCLASS VALUES('MTH101B','F110','MTuTh9','H225',1,25);
INSERT INTO revCLASS VALUES('MTH103C','F110','MWF11','H225',2,2);


INSERT INTO revENROLL VALUES('S1001','ART103A','A');
INSERT INTO revENROLL VALUES('S1001','HST205A','C');
INSERT INTO revENROLL VALUES('S1002','ART103A','D');
INSERT INTO revENROLL VALUES('S1002','CSC201A','F');
INSERT INTO revENROLL VALUES('S1002','MTH103C','B');
INSERT INTO revENROLL(stuId,classNumber) VALUES('S1010','ART103A');
INSERT INTO revENROLL(stuId,classNumber) VALUES('S1010','MTH103C');	
INSERT INTO revENROLL VALUES('S1020','CSC201A','B');
INSERT INTO revENROLL VALUES('S1020','MTH101B','A');